{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_BMa\Subsidies Project\Results\Descriptive_Statistics.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}25 Feb 2021, 11:50:40
{txt}
{com}. 
. 
. use "R:\WSV2\TBu_BMa\Subsidies Project\Data Subsidies\Full Subsidy Data.dta", clear
{txt}
{com}. 
. *******************************************************************************************************************
. *************************************MINIMAL DATA CLEAN************************************************************
. *******************************************************************************************************************
. drop if id==""
{txt}(2,009 observations deleted)

{com}. 
. replace price=. if price<0      & price!=.
{txt}(0 real changes made)

{com}. replace price=. if price==0 & price!=.
{txt}(167,666 real changes made, 167,666 to missing)

{com}. 
. replace price_eur=. if price_eur<0      & price_eur!=.
{txt}(0 real changes made)

{com}. replace price_eur=. if price_eur==0 & price_eur!=.
{txt}(223,775 real changes made, 223,775 to missing)

{com}. 
. replace units=. if units<0      & units!=.
{txt}(151 real changes made, 151 to missing)

{com}. replace units=. if units<2  & units!=.
{txt}(778,810 real changes made, 778,810 to missing)

{com}. 
. replace annual_energy_consumption="" if annual_energy_consumption=="n.a."
{txt}(602,674 real changes made)

{com}. replace annual_energy_consumption="" if annual_energy_consumption=="unknown"
{txt}(260,294 real changes made)

{com}. replace annual_energy_consumption="" if annual_energy_consumption=="0"
{txt}(1,596 real changes made)

{com}. replace annual_energy_consumption="" if annual_energy_consumption=="1"
{txt}(108 real changes made)

{com}. replace annual_energy_consumption="" if annual_energy_consumption=="2"
{txt}(84 real changes made)

{com}. replace annual_energy_consumption="" if annual_energy_consumption=="8500"
{txt}(37 real changes made)

{com}. replace annual_energy_consumption="" if annual_energy_consumption=="9999"
{txt}(12 real changes made)

{com}. destring annual_energy_consumption, replace
{txt}annual_energy_consumption: all characters numeric; {res}replaced {txt}as {res}double
{txt}(868267 missing values generated)
{res}{txt}
{com}. 
. *******************************************************************************************************************
. *************************************SUMMARY STATISTICS FULL DATA**************************************************
. *******************************************************************************************************************
. 
. sum units

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}  1,951,851    70.81991    208.2595          2      24965
{txt}
{com}. replace price_eur=price if country=="Germany"
{txt}(689,407 real changes made)

{com}. replace price_eur=price if country=="Austria"
{txt}(401,757 real changes made)

{com}. 
. sum price_eur

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}  2,339,489    498.7343    355.4176   .0073467      11538
{txt}
{com}. sum annual_energy_consumption

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}  3,319,827     255.292    131.8346         14       3285
{txt}
{com}. 
. by id country, sort: egen       firstyear       =min(year)
{txt}
{com}. by id country, sort: egen       firstdate       =min(date)
{txt}
{com}. by id country, sort: gen        mage            =date-firstdate+1
{txt}
{com}. gen mage2=mage*mage
{txt}
{com}. 
. sum mage

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 8}mage {c |}{res}  4,188,094    27.38245    22.45105          1        157
{txt}
{com}. 
. by id country, sort: gen n=_n
{txt}
{com}. replace n=0 if n>1
{txt}(4,078,188 real changes made)

{com}. by id, sort: egen sumn=sum(n)
{txt}
{com}. 
. sum sumn

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 8}sumn {c |}{res}  4,188,094       2.873    1.875087          1          8
{txt}
{com}. 
. tab country

       {txt}country {c |}      Freq.     Percent        Cum.
{hline 15}{c +}{hline 35}
       Austria {c |}{res}    727,525       17.37       17.37
{txt}       Croatia {c |}{res}    262,419        6.27       23.64
{txt}Czech Republic {c |}{res}    583,006       13.92       37.56
{txt}       Germany {c |}{res}  1,148,277       27.42       64.98
{txt}       Hungary {c |}{res}    434,957       10.39       75.36
{txt}        Poland {c |}{res}    599,731       14.32       89.68
{txt}        Serbia {c |}{res}    171,101        4.09       93.77
{txt}      Slovenia {c |}{res}    261,078        6.23      100.00
{txt}{hline 15}{c +}{hline 35}
         Total {c |}{res}  4,188,094      100.00
{txt}
{com}. tab category

       {txt}category {c |}      Freq.     Percent        Cum.
{hline 16}{c +}{hline 35}
        freezer {c |}{res}    486,700       11.62       11.62
{txt}   refrigerator {c |}{res}  2,360,234       56.36       67.98
{txt}washing machine {c |}{res}  1,341,160       32.02      100.00
{txt}{hline 16}{c +}{hline 35}
          Total {c |}{res}  4,188,094      100.00
{txt}
{com}. 
. *******************************************************************************************************************
. *************************************SUMMARY STATISTICS BY PRODUCT CATEGORY****************************************
. *******************************************************************************************************************
. 
. sum units                                                       if (category=="refrigerator"|category=="freezer")

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}  1,299,194    59.23015    151.8471          2      11086
{txt}
{com}. sum price_eur                                           if (category=="refrigerator"|category=="freezer")

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}  1,577,530     522.411    395.1319   .0073467      11538
{txt}
{com}. sum annual_energy_consumption           if (category=="refrigerator"|category=="freezer")

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}  2,753,340     258.893    102.7644         14       3285
{txt}
{com}. 
. 
. sum units                                                       if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}     43,349    76.27361    171.0742          2   5304.204
{txt}
{com}. sum price_eur                                           if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}     50,866    789.7518      322.39         50       3200
{txt}
{com}. sum annual_energy_consumption           if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}     86,813    149.9069    36.60454         51        360
{txt}
{com}. 
. 
. sum units                                                       if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}    252,600    59.75988    134.5809          2   4291.167
{txt}
{com}. sum price_eur                                           if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}    297,520    629.2666     381.584         40       6919
{txt}
{com}. sum annual_energy_consumption           if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}    506,977     198.138    62.26495         62        542
{txt}
{com}. 
. sum units                                                       if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A+"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}    501,711    60.20711    153.3013          2   8384.471
{txt}
{com}. sum price_eur                                           if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A+"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}    602,177     514.585    412.6111          2   9432.705
{txt}
{com}. sum annual_energy_consumption           if (category=="refrigerator"|category=="freezer") & energy_label_eu=="A+"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}  1,051,175     252.293    85.71037         41       1257
{txt}
{com}. 
. sum units                                                       if (category=="refrigerator"|category=="freezer") & energy_label_eu!="A+" & energy_label_eu!="A++" &energy_label_eu!="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}    501,534    56.51293    156.6345          2      11086
{txt}
{com}. sum price_eur                                           if (category=="refrigerator"|category=="freezer") & energy_label_eu!="A+" & energy_label_eu!="A++" &energy_label_eu!="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}    626,967    457.5311    369.2051   .0073467      11538
{txt}
{com}. sum annual_energy_consumption           if (category=="refrigerator"|category=="freezer") & energy_label_eu!="A+" & energy_label_eu!="A++" &energy_label_eu!="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}  1,108,375    301.4785    113.6428         14       3285
{txt}
{com}. 
. 
. sum units                                                       if (category=="washing machine")

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}    652,657    93.89075    288.1161          2      24965
{txt}
{com}. sum price_eur                                           if (category=="washing machine")

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}    761,959     449.715    247.0748   .3663004   3504.264
{txt}
{com}. sum annual_energy_consumption           if (category=="washing machine")

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}    566,487    237.7894    223.9601         58       1797
{txt}
{com}. 
. 
. sum units                                                       if (category=="washing machine") & energy_label_eu=="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}    142,988    118.0424    359.8136          2   11041.26
{txt}
{com}. sum price_eur                                           if (category=="washing machine")  & energy_label_eu=="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}    161,814    541.0372    280.4584      49.99   3504.264
{txt}
{com}. sum annual_energy_consumption           if (category=="washing machine")  & energy_label_eu=="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}    241,607    168.4301    27.96075         58        381
{txt}
{com}. 
. 
. sum units                                                       if (category=="washing machine") & energy_label_eu=="A++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}     58,574    100.1328    291.4663          2   8750.817
{txt}
{com}. sum price_eur                                           if (category=="washing machine") & energy_label_eu=="A++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}     66,870    378.3029    143.1929   92.47602   1880.625
{txt}
{com}. sum annual_energy_consumption           if (category=="washing machine") & energy_label_eu=="A++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}    100,994    184.9342    27.85065        105        434
{txt}
{com}. 
. sum units                                                       if (category=="washing machine") & energy_label_eu=="A+"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}     97,049    97.91127    238.6822          2       7581
{txt}
{com}. sum price_eur                                           if (category=="washing machine") & energy_label_eu=="A+"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}    110,520    369.7151    199.2598      48.17   2101.733
{txt}
{com}. sum annual_energy_consumption           if (category=="washing machine") & energy_label_eu=="A+"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}    137,493      190.12    29.23326        109        485
{txt}
{com}. 
. sum units                                                       if (category=="washing machine") & energy_label_eu!="A+" & energy_label_eu!="A++" &energy_label_eu!="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}    354,046     82.0019    265.8558          2      24965
{txt}
{com}. sum price_eur                                           if (category=="washing machine") & energy_label_eu!="A+" & energy_label_eu!="A++" &energy_label_eu!="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}    422,755    446.9703    246.2074   .3663004   3471.678
{txt}
{com}. sum annual_energy_consumption           if (category=="washing machine") & energy_label_eu!="A+" & energy_label_eu!="A++" &energy_label_eu!="A+++"

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}     86,393    569.4131    440.6017      99.84       1797
{txt}
{com}. 
. 
. 
.  *********************************************
.  ***** DROP MODELS SOLD IN ONLY ONE COUNTRY***
.  *********************************************
. 
. tab sumn 

       {txt}sumn {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}  1,200,061       28.65       28.65
{txt}          2 {c |}{res}  1,118,508       26.71       55.36
{txt}          3 {c |}{res}    586,454       14.00       69.36
{txt}          4 {c |}{res}    404,745        9.66       79.03
{txt}          5 {c |}{res}    377,206        9.01       88.03
{txt}          6 {c |}{res}    267,249        6.38       94.42
{txt}          7 {c |}{res}    143,518        3.43       97.84
{txt}          8 {c |}{res}     90,353        2.16      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  4,188,094      100.00
{txt}
{com}. drop if sumn==1
{txt}(1,200,061 observations deleted)

{com}. 
. 
.  ************************************************************************
.  ***** DROP MODELS SOLD IN ONLY ONE COUNTRY WITHIN A PRODUCT-DATE CELL***
.  ************************************************************************
. 
. by id country date, sort: gen j=_n
{txt}
{com}. replace j=0 if j>1
{txt}(0 real changes made)

{com}. by id date, sort: egen sumj=sum(j)
{txt}
{com}. 
. tab sumj 

       {txt}sumj {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          1 {c |}{res}    474,672       15.89       15.89
{txt}          2 {c |}{res}  1,125,710       37.67       53.56
{txt}          3 {c |}{res}    535,272       17.91       71.47
{txt}          4 {c |}{res}    350,820       11.74       83.21
{txt}          5 {c |}{res}    263,845        8.83       92.04
{txt}          6 {c |}{res}    146,214        4.89       96.94
{txt}          7 {c |}{res}     67,732        2.27       99.20
{txt}          8 {c |}{res}     23,768        0.80      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}  2,988,033      100.00
{txt}
{com}. 
. drop if sumj==1
{txt}(474,672 observations deleted)

{com}. 
.  
. *******************************************************************************************************************
. *************************************SUMMARY STATISTICS ESTIMATION SAMPLE******************************************
. *******************************************************************************************************************
. 
. sum units

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 7}units {c |}{res}  1,294,233    74.17321    211.5295          2      19062
{txt}
{com}. sum price_eur

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 3}price_eur {c |}{res}  1,535,039    523.4403     371.369   .3640998      11538
{txt}
{com}. sum mage

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 8}mage {c |}{res}  2,513,361    26.31109    20.32952          1        157
{txt}
{com}. sum annual_energy_consumption

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
annual_ene~n {c |}{res}  2,124,153    251.9127    136.0425         51       1768
{txt}
{com}. sum sumn

{txt}    Variable {c |}        Obs        Mean    Std. Dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 8}sumn {c |}{res}  2,513,361    3.819423    1.747212          2          8
{txt}
{com}. 
. tab country

       {txt}country {c |}      Freq.     Percent        Cum.
{hline 15}{c +}{hline 35}
       Austria {c |}{res}    489,822       19.49       19.49
{txt}       Croatia {c |}{res}    182,208        7.25       26.74
{txt}Czech Republic {c |}{res}    389,036       15.48       42.22
{txt}       Germany {c |}{res}    528,649       21.03       63.25
{txt}       Hungary {c |}{res}    312,964       12.45       75.70
{txt}        Poland {c |}{res}    289,157       11.50       87.21
{txt}        Serbia {c |}{res}    111,416        4.43       91.64
{txt}      Slovenia {c |}{res}    210,109        8.36      100.00
{txt}{hline 15}{c +}{hline 35}
         Total {c |}{res}  2,513,361      100.00
{txt}
{com}. tab category

       {txt}category {c |}      Freq.     Percent        Cum.
{hline 16}{c +}{hline 35}
        freezer {c |}{res}    299,935       11.93       11.93
{txt}   refrigerator {c |}{res}  1,441,050       57.34       69.27
{txt}washing machine {c |}{res}    772,376       30.73      100.00
{txt}{hline 16}{c +}{hline 35}
          Total {c |}{res}  2,513,361      100.00
{txt}
{com}. 
. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}R:\WSV2\TBu_BMa\Subsidies Project\Results\Descriptive_Statistics.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}25 Feb 2021, 11:54:04
{txt}{.-}
{smcl}
{txt}{sf}{ul off}